CREATE database if NOT EXISTS `aa` default character set utf8;
use `aa`;

DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pname` varchar(16) NOT NULL DEFAULT '' COMMENT '姓名',
  `psex` varchar(16) NOT NULL DEFAULT '' COMMENT '性别',
  PRIMARY KEY (`id`)
);

BEGIN;
INSERT INTO person(pname,psex) VALUES ('gab', '男');
INSERT INTO person(pname,psex) VALUES ('bb', '女');
COMMIT;